Setting Format Options

Format options specifies for file type.

TXT, CSV

Define Field Delimiter, Record Delimiter and Text Qualifier for file. Record delimiter indicates how the file recognizes as new record (row).



XML

Define tag to identify table row.

Consider tag's attributes as table's field
For example:

<row age="17">
<id>1</id>
<name>sze</name>
</row>

With this option is on, Navicat will recognizes "age" as a table field together with "id" and "name", otherwise, only "id" and "name" will be imported as table fields.

Note: Navicat does not support multiple level of XML file.



Excel

Select the worksheet(s) you wish to import from the excel source file. Each worksheet will be imported as a separate table.